﻿CREATE TYPE [flcr].[DEVICE_PLATFORM_UDT] AS  TABLE (
    [DEVICE_PLATFORM_ID] INT           NULL,
    [AUDIT_USER]         VARCHAR (100) NULL,
    [AUDIT_DTTM]         DATETIME      NULL,
    [AUDIT_DTTM_TZ]      INT           NULL,
    [AUDIT_MOD_USER]     VARCHAR (100) NULL,
    [AUDIT_MOD_DTTM]     DATETIME      NULL,
    [AUDIT_MOD_DTTM_TZ]  INT           NULL,
    [BUILTIN]            BIT           NULL,
    [WRKFL_ITEM_ID]      INT           NULL,
    [WRKFL_STATUS_ID]    INT           NULL,
    [ACTIVE_FLG]         BIT           NULL,
    [SORT_ORDER]         INT           NULL,
    [SUPPLIER_ID]        INT           NULL,
    [PLATFORM_NAME]      VARCHAR (100) NULL,
    [MODEL_NAME]         VARCHAR (100) NULL,
    [MODEL_NUM]          VARCHAR (100) NULL,
    [SKU_PART_NUM]       VARCHAR (100) NULL,
    [OEM_EOL_DT]         DATE          NULL,
    [OEM_EOSUP_DT]       DATE          NULL,
    [OWNER_EOSL_DT]      DATE          NULL,
    [OWNER_PEOSL_DT]     DATE          NULL,
    [IMAGE_FILE]         VARBINARY (1) NULL);

